Final Exam: Database Developer

Final Exam: Database Developer

• add rows to a database table by running an INSERT query from a Java app
• adopt a DataSource object to create a Connection with a database
• compare and contrast a JdbcRowSet and ResultSet
• configure eager loading of entities on the many sides
• configure lazy and eager loading for collections
• configure lazy loading of entities on the many sides
• configure one-to-one mapping with a join table
• configure one-to-one-mapping with a shared primary key
• configure the table name using the @Table annotation
• contrast the AUTO and IDENTITY generation types
• define collection mapping for primitive data types
• describe the features offered by a WebRowSet
• describe the role of batch updates and transactions when working with JDBC
• describe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a database
• download and install MySQL and the MySQL Workbench tool
• download image files from a SQL table into your file system
• drop a table and database from a Java app
• execute JPQL queries
• execute native queries
• execute stored procedures that return values and retrieve the outputs generated
• hook into the entity lifecycle
• hook into the entity lifecycle after load
• hook into the entity lifecycle before and after entity load
• identify the different JDBC objects that enable a Java app to work with a database, and recall the role played by each of them
• identify the different ways to specify connection details when connecting to a database using JDBC
• identify the implications of cascade type NONE
• identify the types of ResultSets available in JDBC
• identify why object-relational mapping is needed to work with databases
• install MySQL and MySQL Workbench on a Windows machine
• load large image files into a SQL table using JDBC
• outline the basic functionality that the Hibernate framework provides and how it differs to JPA
• outline the basic functionality that the JPA framework provides and how it differs to Hibernate
• perform an update and delete operations on entities
• perform read operations on database entities
• perform scrolling and navigation over the contents of a JdbcRowSet
• persist collections using the Set interface
• persist entities in a certain order
• persist nested objects in collections
• recall how a WebRowSet records modifications to its contents
• recall the implications of cascade type NONE
• recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
• recognize the primary key as a required field
• refresh the contents of a ResultSet
• refresh the contents of a ResultSet while iterating over its contents
• remove data from a SQL table by performing deletes from a ResultSet
• retrieve many entities in order of specific attributes
• run basic criteria queries
• scroll through a ResultSet to access data in various locations
• set up a bidirectional one-to-one mapping between entities
• set up an Apache Maven project on a Windows machine
• set up a one-to-one mapping between entities
• specify entity attributes using XML
• summarize the basic structure of the Criteria API
• summarize the effects of cascade type MERGE
• summarize the effects of cascade type PERSIST and REMOVE
• use a CachedRowSet to work with data while disconnected from the database
• use begin and commit transactions
• use database connection details in a properties file to set up a connection to a database using JDBC
• use @GeneratedValue to generate primary key values
• use the IDENTITY generation type for multiple tables

Final Exam: Database Developer will test your knowledge and application of the topics presented throughout the Database Developer track of the Skillsoft Aspire Developer to App Architect Journey.

JDBC: Advanced Topics

JDBC: Advanced Topics

• discover the key concepts covered in this course
• load large image files into a SQL table using JDBC
• download image files from a SQL table into your file system
• use JDBC to upload and download text data to and from a database
• create and execute stored procedures from a Java application
• execute stored procedures that return values and retrieve the outputs generated
• use JDBC to run stored procedures that use the same parameter to process inputs and outputs
• summarize the key concepts covered in this course

When building Java apps which interact with a database, you may need to work with stored procedures and also large binary objects. The goal of this course is to give you hands-on experience with the handling of binary and text data and working with stored procedures. You will load image and text files from your file system to a database using JDBC, and will then do the reverse operations. You will also create and execute a variety of stored procedures from a Java app.

JDBC: An Introduction to Java Database Connectivity

JDBC: An Introduction to Java Database Connectivity

• discover the key concepts covered in this course
• describe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a database
• identify the different JDBC objects that enable a Java app to work with a database, and recall the roll played by each of them
• recognize the role played by a ResultSet in navigating over and modifying the contents of tabular data
• recall the specific types of RowSets available in JDBC and their specific features and use cases
• describe the role of batch updates and transactions when working with JDBC
• download and install MySQL and the MySQL Workbench tool
• write a Java app that connects to a database using JDBC
• configure a Java app to use a JDBC driver when connecting to a database
• set up a Maven project to work with a JDBC driver
• summarize the key concepts covered in this course

Before getting your hands dirty with Java Database Connectivity (JDBC), it is important to recognize its purporse and the options it has to offer - and this is exactly what this course provides. It first lays a theoretical foundation in terms of the need for JDBC, the various pieces which come together to let your app connect to a database, as well as their features and use cases. You will cover topics such as JDBC drivers, JDBC objects such as Statement , ResultSet, and RowSet, and then connect a Java app to a database.

JDBC: Executing Statements

JDBC: Executing Statements

• discover the key concepts covered in this course
• identify the different ways to specify connection details when connecting to a database using JDBC
• use database connection details in a properties file to set up a connection to a database using JDBC
• adopt a DataSource object to create a Connection with a database
• execute a SQL query to create a database table from a Java app
• run a SELECT query against a database and access the returned tabular data in a JDBC ResultSet object
• add rows to a database table by running an INSERT query from a Java app
• modify the contents of a database table from a Java app by executing UPDATE and DELETE queries
• drop a table and database from a Java app
• recognize the limitations of the Statement object when several executions of similar queries are involved
• optimize the execution of similar queries by parametrizing them with PreparedStatements
• recall the types of exceptions that could occur when passing incorrect parameters to a PreparedStatement
• identify some of the exceptions that could be thrown when using JDBC to work with databases
• summarize the key concepts covered in this course

Java Database Connectivity (JDBC) offers a number of ways in which SQL queries can be executed using a number of built-in objects. This demo-based course covers the use of the fundamental JDBC objects required to set up and manage database connections from a Java app and to execute queries. You will cover the use of Properties objects to load connection details, and then the use of the Statement and PreparedStatement instances to run SELECT, INSERT, DELETE and UPDATE queries against a database from a Java app.

JDBC: RowSet

JDBC: RowSet

• discover the key concepts covered in this course
• compare and contrast a JdbcRowSet and ResultSet
• perform scrolling and navigation over the contents of a JdbcRowSet
• update the contents of a SQL table through a JdbcRowSet
• use a CachedRowSet to work with a data while disconnected from the database
• recognize the limitations of working with a disconnected RowSet such as a CachedRowSet
• manipulate the contents of a CachedRowSet and push the updates to the underlying database table
• perform an offline join of two tables using a JoinRowSet
• update the contents of a SQL table through a JoinRowSet
• define a Predicate class that sets up a filter for a FilteredRowSet
• apply a Predicate instance to a FilteredRowSet to get it to include only data that fulfils the condition defined in the Predicate
• recognize the types of updates that can be performed on a FilteredRowSet
• describe the features offered by a WebRowSet
• recall how a WebRowSet records modifications to its contents
• summarize the key concepts covered in this course

The JDBC RowSet offers the same functionality as a ResultSet with several useful additional features. This course involves a number of demos covering different RowSet types. You will explore the features of the JdbcRowSet which is a type of connected RowSet and is similar to a ResultSet. You will then cover different flavors of disconnected RowSets - from the CachedRowSet and the WebRowSet to performing offline joins using the JoinRowSet and filtering rows using the FilteredRowSet.

JDBC: Working with ResultSets & Query Batches

JDBC: Working with ResultSets & Query Batches

• discover the key concepts covered in this course
• identify the types of ResultSets available in JDBC
• scroll through a ResultSet to access data in various locations
• recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
• refresh the contents of a ResultSet while iterating over its contents
• recognize the types of modifications that a ResultSet may not pick up
• modify the contents of a SQL table by updating a ResultSet
• remove data from a SQL table by performing deletes from a ResultSet
• identify potential issues when trying to modify a read-only ResultSet
• group similar INSERT queries together into a bath to optimize their executions
• combine the optimizations of batch executions and batch updates
• describe how the auto-commit feature may prevent queries from running as a transaction
• use the rollback feature of JDBC to undo modifications after an Exception is thrown
• perform a partial rollback by implementing Savepoints in a Java app
• summarize the key concepts covered in this course

ResultSets allow SELECT query results to be processed systematically in a Java app while executing INSERT and UPDATE queries can be handled efficiently with query batches. This is very much a hands-on course and gets into the nitty-gritty of processing large volumes of data using JDBC. You will cover a lot of features of the ResultSet object - from its navigability to its ability to update data. You will also optimize updates by running them in a batch, and cover the implementations of atomic transactions when using JDBC.